package com.crm.model.entity.customerManager;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class CustomerExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CustomerExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("customer_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(String value) {
            addCriterion("customer_id =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(String value) {
            addCriterion("customer_id <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(String value) {
            addCriterion("customer_id >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("customer_id >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(String value) {
            addCriterion("customer_id <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("customer_id <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLike(String value) {
            addCriterion("customer_id like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotLike(String value) {
            addCriterion("customer_id not like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<String> values) {
            addCriterion("customer_id in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<String> values) {
            addCriterion("customer_id not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(String value1, String value2) {
            addCriterion("customer_id between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(String value1, String value2) {
            addCriterion("customer_id not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberIsNull() {
            addCriterion("customer_number is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberIsNotNull() {
            addCriterion("customer_number is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberEqualTo(String value) {
            addCriterion("customer_number =", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberNotEqualTo(String value) {
            addCriterion("customer_number <>", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberGreaterThan(String value) {
            addCriterion("customer_number >", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberGreaterThanOrEqualTo(String value) {
            addCriterion("customer_number >=", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberLessThan(String value) {
            addCriterion("customer_number <", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberLessThanOrEqualTo(String value) {
            addCriterion("customer_number <=", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberLike(String value) {
            addCriterion("customer_number like", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberNotLike(String value) {
            addCriterion("customer_number not like", value, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberIn(List<String> values) {
            addCriterion("customer_number in", values, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberNotIn(List<String> values) {
            addCriterion("customer_number not in", values, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberBetween(String value1, String value2) {
            addCriterion("customer_number between", value1, value2, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNumberNotBetween(String value1, String value2) {
            addCriterion("customer_number not between", value1, value2, "customerNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIsNull() {
            addCriterion("customer_type is null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIsNotNull() {
            addCriterion("customer_type is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeEqualTo(String value) {
            addCriterion("customer_type =", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotEqualTo(String value) {
            addCriterion("customer_type <>", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeGreaterThan(String value) {
            addCriterion("customer_type >", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_type >=", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeLessThan(String value) {
            addCriterion("customer_type <", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeLessThanOrEqualTo(String value) {
            addCriterion("customer_type <=", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeLike(String value) {
            addCriterion("customer_type like", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotLike(String value) {
            addCriterion("customer_type not like", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIn(List<String> values) {
            addCriterion("customer_type in", values, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotIn(List<String> values) {
            addCriterion("customer_type not in", values, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeBetween(String value1, String value2) {
            addCriterion("customer_type between", value1, value2, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotBetween(String value1, String value2) {
            addCriterion("customer_type not between", value1, value2, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelIsNull() {
            addCriterion("customer_level is null");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelIsNotNull() {
            addCriterion("customer_level is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelEqualTo(String value) {
            addCriterion("customer_level =", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelNotEqualTo(String value) {
            addCriterion("customer_level <>", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelGreaterThan(String value) {
            addCriterion("customer_level >", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelGreaterThanOrEqualTo(String value) {
            addCriterion("customer_level >=", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelLessThan(String value) {
            addCriterion("customer_level <", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelLessThanOrEqualTo(String value) {
            addCriterion("customer_level <=", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelLike(String value) {
            addCriterion("customer_level like", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelNotLike(String value) {
            addCriterion("customer_level not like", value, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelIn(List<String> values) {
            addCriterion("customer_level in", values, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelNotIn(List<String> values) {
            addCriterion("customer_level not in", values, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelBetween(String value1, String value2) {
            addCriterion("customer_level between", value1, value2, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andCustomerLevelNotBetween(String value1, String value2) {
            addCriterion("customer_level not between", value1, value2, "customerLevel");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeIsNull() {
            addCriterion("unified_social_credit_code is null");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeIsNotNull() {
            addCriterion("unified_social_credit_code is not null");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeEqualTo(String value) {
            addCriterion("unified_social_credit_code =", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeNotEqualTo(String value) {
            addCriterion("unified_social_credit_code <>", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeGreaterThan(String value) {
            addCriterion("unified_social_credit_code >", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeGreaterThanOrEqualTo(String value) {
            addCriterion("unified_social_credit_code >=", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLessThan(String value) {
            addCriterion("unified_social_credit_code <", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLessThanOrEqualTo(String value) {
            addCriterion("unified_social_credit_code <=", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLike(String value) {
            addCriterion("unified_social_credit_code like", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeNotLike(String value) {
            addCriterion("unified_social_credit_code not like", value, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeIn(List<String> values) {
            addCriterion("unified_social_credit_code in", values, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeNotIn(List<String> values) {
            addCriterion("unified_social_credit_code not in", values, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeBetween(String value1, String value2) {
            addCriterion("unified_social_credit_code between", value1, value2, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeNotBetween(String value1, String value2) {
            addCriterion("unified_social_credit_code not between", value1, value2, "unifiedSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIsNull() {
            addCriterion("original_customer_id is null");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIsNotNull() {
            addCriterion("original_customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdEqualTo(String value) {
            addCriterion("original_customer_id =", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotEqualTo(String value) {
            addCriterion("original_customer_id <>", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdGreaterThan(String value) {
            addCriterion("original_customer_id >", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("original_customer_id >=", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLessThan(String value) {
            addCriterion("original_customer_id <", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("original_customer_id <=", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLike(String value) {
            addCriterion("original_customer_id like", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotLike(String value) {
            addCriterion("original_customer_id not like", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIn(List<String> values) {
            addCriterion("original_customer_id in", values, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotIn(List<String> values) {
            addCriterion("original_customer_id not in", values, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdBetween(String value1, String value2) {
            addCriterion("original_customer_id between", value1, value2, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotBetween(String value1, String value2) {
            addCriterion("original_customer_id not between", value1, value2, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstIsNull() {
            addCriterion("customer_industry_first is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstIsNotNull() {
            addCriterion("customer_industry_first is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstEqualTo(String value) {
            addCriterion("customer_industry_first =", value, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstNotEqualTo(String value) {
            addCriterion("customer_industry_first <>", value, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstGreaterThan(String value) {
            addCriterion("customer_industry_first >", value, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstGreaterThanOrEqualTo(String value) {
            addCriterion("customer_industry_first >=", value, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstLessThan(String value) {
            addCriterion("customer_industry_first <", value, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstLessThanOrEqualTo(String value) {
            addCriterion("customer_industry_first <=", value, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstLike(String value) {
            addCriterion("customer_industry_first like", value, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstNotLike(String value) {
            addCriterion("customer_industry_first not like", value, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstIn(List<String> values) {
            addCriterion("customer_industry_first in", values, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstNotIn(List<String> values) {
            addCriterion("customer_industry_first not in", values, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstBetween(String value1, String value2) {
            addCriterion("customer_industry_first between", value1, value2, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustryFirstNotBetween(String value1, String value2) {
            addCriterion("customer_industry_first not between", value1, value2, "customerIndustryFirst");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondIsNull() {
            addCriterion("customer_industry_second is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondIsNotNull() {
            addCriterion("customer_industry_second is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondEqualTo(String value) {
            addCriterion("customer_industry_second =", value, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondNotEqualTo(String value) {
            addCriterion("customer_industry_second <>", value, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondGreaterThan(String value) {
            addCriterion("customer_industry_second >", value, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondGreaterThanOrEqualTo(String value) {
            addCriterion("customer_industry_second >=", value, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondLessThan(String value) {
            addCriterion("customer_industry_second <", value, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondLessThanOrEqualTo(String value) {
            addCriterion("customer_industry_second <=", value, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondLike(String value) {
            addCriterion("customer_industry_second like", value, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondNotLike(String value) {
            addCriterion("customer_industry_second not like", value, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondIn(List<String> values) {
            addCriterion("customer_industry_second in", values, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondNotIn(List<String> values) {
            addCriterion("customer_industry_second not in", values, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondBetween(String value1, String value2) {
            addCriterion("customer_industry_second between", value1, value2, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andCustomerIndustrySecondNotBetween(String value1, String value2) {
            addCriterion("customer_industry_second not between", value1, value2, "customerIndustrySecond");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIsNull() {
            addCriterion("province_code is null");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIsNotNull() {
            addCriterion("province_code is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeEqualTo(String value) {
            addCriterion("province_code =", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotEqualTo(String value) {
            addCriterion("province_code <>", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeGreaterThan(String value) {
            addCriterion("province_code >", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("province_code >=", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLessThan(String value) {
            addCriterion("province_code <", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLessThanOrEqualTo(String value) {
            addCriterion("province_code <=", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLike(String value) {
            addCriterion("province_code like", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotLike(String value) {
            addCriterion("province_code not like", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIn(List<String> values) {
            addCriterion("province_code in", values, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotIn(List<String> values) {
            addCriterion("province_code not in", values, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeBetween(String value1, String value2) {
            addCriterion("province_code between", value1, value2, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotBetween(String value1, String value2) {
            addCriterion("province_code not between", value1, value2, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIsNull() {
            addCriterion("province_name is null");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIsNotNull() {
            addCriterion("province_name is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceNameEqualTo(String value) {
            addCriterion("province_name =", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotEqualTo(String value) {
            addCriterion("province_name <>", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameGreaterThan(String value) {
            addCriterion("province_name >", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameGreaterThanOrEqualTo(String value) {
            addCriterion("province_name >=", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLessThan(String value) {
            addCriterion("province_name <", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLessThanOrEqualTo(String value) {
            addCriterion("province_name <=", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLike(String value) {
            addCriterion("province_name like", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotLike(String value) {
            addCriterion("province_name not like", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIn(List<String> values) {
            addCriterion("province_name in", values, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotIn(List<String> values) {
            addCriterion("province_name not in", values, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameBetween(String value1, String value2) {
            addCriterion("province_name between", value1, value2, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotBetween(String value1, String value2) {
            addCriterion("province_name not between", value1, value2, "provinceName");
            return (Criteria) this;
        }

        public Criteria andCityCodeIsNull() {
            addCriterion("city_code is null");
            return (Criteria) this;
        }

        public Criteria andCityCodeIsNotNull() {
            addCriterion("city_code is not null");
            return (Criteria) this;
        }

        public Criteria andCityCodeEqualTo(String value) {
            addCriterion("city_code =", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotEqualTo(String value) {
            addCriterion("city_code <>", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeGreaterThan(String value) {
            addCriterion("city_code >", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeGreaterThanOrEqualTo(String value) {
            addCriterion("city_code >=", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLessThan(String value) {
            addCriterion("city_code <", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLessThanOrEqualTo(String value) {
            addCriterion("city_code <=", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLike(String value) {
            addCriterion("city_code like", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotLike(String value) {
            addCriterion("city_code not like", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeIn(List<String> values) {
            addCriterion("city_code in", values, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotIn(List<String> values) {
            addCriterion("city_code not in", values, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeBetween(String value1, String value2) {
            addCriterion("city_code between", value1, value2, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotBetween(String value1, String value2) {
            addCriterion("city_code not between", value1, value2, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNull() {
            addCriterion("city_name is null");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNotNull() {
            addCriterion("city_name is not null");
            return (Criteria) this;
        }

        public Criteria andCityNameEqualTo(String value) {
            addCriterion("city_name =", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotEqualTo(String value) {
            addCriterion("city_name <>", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThan(String value) {
            addCriterion("city_name >", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("city_name >=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThan(String value) {
            addCriterion("city_name <", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThanOrEqualTo(String value) {
            addCriterion("city_name <=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLike(String value) {
            addCriterion("city_name like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotLike(String value) {
            addCriterion("city_name not like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameIn(List<String> values) {
            addCriterion("city_name in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotIn(List<String> values) {
            addCriterion("city_name not in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameBetween(String value1, String value2) {
            addCriterion("city_name between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotBetween(String value1, String value2) {
            addCriterion("city_name not between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andCountyCodeIsNull() {
            addCriterion("county_code is null");
            return (Criteria) this;
        }

        public Criteria andCountyCodeIsNotNull() {
            addCriterion("county_code is not null");
            return (Criteria) this;
        }

        public Criteria andCountyCodeEqualTo(String value) {
            addCriterion("county_code =", value, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeNotEqualTo(String value) {
            addCriterion("county_code <>", value, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeGreaterThan(String value) {
            addCriterion("county_code >", value, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("county_code >=", value, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeLessThan(String value) {
            addCriterion("county_code <", value, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeLessThanOrEqualTo(String value) {
            addCriterion("county_code <=", value, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeLike(String value) {
            addCriterion("county_code like", value, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeNotLike(String value) {
            addCriterion("county_code not like", value, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeIn(List<String> values) {
            addCriterion("county_code in", values, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeNotIn(List<String> values) {
            addCriterion("county_code not in", values, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeBetween(String value1, String value2) {
            addCriterion("county_code between", value1, value2, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyCodeNotBetween(String value1, String value2) {
            addCriterion("county_code not between", value1, value2, "countyCode");
            return (Criteria) this;
        }

        public Criteria andCountyNameIsNull() {
            addCriterion("county_name is null");
            return (Criteria) this;
        }

        public Criteria andCountyNameIsNotNull() {
            addCriterion("county_name is not null");
            return (Criteria) this;
        }

        public Criteria andCountyNameEqualTo(String value) {
            addCriterion("county_name =", value, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameNotEqualTo(String value) {
            addCriterion("county_name <>", value, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameGreaterThan(String value) {
            addCriterion("county_name >", value, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameGreaterThanOrEqualTo(String value) {
            addCriterion("county_name >=", value, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameLessThan(String value) {
            addCriterion("county_name <", value, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameLessThanOrEqualTo(String value) {
            addCriterion("county_name <=", value, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameLike(String value) {
            addCriterion("county_name like", value, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameNotLike(String value) {
            addCriterion("county_name not like", value, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameIn(List<String> values) {
            addCriterion("county_name in", values, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameNotIn(List<String> values) {
            addCriterion("county_name not in", values, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameBetween(String value1, String value2) {
            addCriterion("county_name between", value1, value2, "countyName");
            return (Criteria) this;
        }

        public Criteria andCountyNameNotBetween(String value1, String value2) {
            addCriterion("county_name not between", value1, value2, "countyName");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressIsNull() {
            addCriterion("detailed_address is null");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressIsNotNull() {
            addCriterion("detailed_address is not null");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressEqualTo(String value) {
            addCriterion("detailed_address =", value, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressNotEqualTo(String value) {
            addCriterion("detailed_address <>", value, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressGreaterThan(String value) {
            addCriterion("detailed_address >", value, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressGreaterThanOrEqualTo(String value) {
            addCriterion("detailed_address >=", value, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressLessThan(String value) {
            addCriterion("detailed_address <", value, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressLessThanOrEqualTo(String value) {
            addCriterion("detailed_address <=", value, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressLike(String value) {
            addCriterion("detailed_address like", value, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressNotLike(String value) {
            addCriterion("detailed_address not like", value, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressIn(List<String> values) {
            addCriterion("detailed_address in", values, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressNotIn(List<String> values) {
            addCriterion("detailed_address not in", values, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressBetween(String value1, String value2) {
            addCriterion("detailed_address between", value1, value2, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andDetailedAddressNotBetween(String value1, String value2) {
            addCriterion("detailed_address not between", value1, value2, "detailedAddress");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneIsNull() {
            addCriterion("enterprise_external_phone is null");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneIsNotNull() {
            addCriterion("enterprise_external_phone is not null");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneEqualTo(String value) {
            addCriterion("enterprise_external_phone =", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneNotEqualTo(String value) {
            addCriterion("enterprise_external_phone <>", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneGreaterThan(String value) {
            addCriterion("enterprise_external_phone >", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("enterprise_external_phone >=", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneLessThan(String value) {
            addCriterion("enterprise_external_phone <", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneLessThanOrEqualTo(String value) {
            addCriterion("enterprise_external_phone <=", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneLike(String value) {
            addCriterion("enterprise_external_phone like", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneNotLike(String value) {
            addCriterion("enterprise_external_phone not like", value, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneIn(List<String> values) {
            addCriterion("enterprise_external_phone in", values, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneNotIn(List<String> values) {
            addCriterion("enterprise_external_phone not in", values, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneBetween(String value1, String value2) {
            addCriterion("enterprise_external_phone between", value1, value2, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andEnterpriseExternalPhoneNotBetween(String value1, String value2) {
            addCriterion("enterprise_external_phone not between", value1, value2, "enterpriseExternalPhone");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteIsNull() {
            addCriterion("company_website is null");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteIsNotNull() {
            addCriterion("company_website is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteEqualTo(String value) {
            addCriterion("company_website =", value, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteNotEqualTo(String value) {
            addCriterion("company_website <>", value, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteGreaterThan(String value) {
            addCriterion("company_website >", value, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteGreaterThanOrEqualTo(String value) {
            addCriterion("company_website >=", value, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteLessThan(String value) {
            addCriterion("company_website <", value, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteLessThanOrEqualTo(String value) {
            addCriterion("company_website <=", value, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteLike(String value) {
            addCriterion("company_website like", value, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteNotLike(String value) {
            addCriterion("company_website not like", value, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteIn(List<String> values) {
            addCriterion("company_website in", values, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteNotIn(List<String> values) {
            addCriterion("company_website not in", values, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteBetween(String value1, String value2) {
            addCriterion("company_website between", value1, value2, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanyWebsiteNotBetween(String value1, String value2) {
            addCriterion("company_website not between", value1, value2, "companyWebsite");
            return (Criteria) this;
        }

        public Criteria andCompanySizeIsNull() {
            addCriterion("company_size is null");
            return (Criteria) this;
        }

        public Criteria andCompanySizeIsNotNull() {
            addCriterion("company_size is not null");
            return (Criteria) this;
        }

        public Criteria andCompanySizeEqualTo(String value) {
            addCriterion("company_size =", value, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeNotEqualTo(String value) {
            addCriterion("company_size <>", value, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeGreaterThan(String value) {
            addCriterion("company_size >", value, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeGreaterThanOrEqualTo(String value) {
            addCriterion("company_size >=", value, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeLessThan(String value) {
            addCriterion("company_size <", value, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeLessThanOrEqualTo(String value) {
            addCriterion("company_size <=", value, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeLike(String value) {
            addCriterion("company_size like", value, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeNotLike(String value) {
            addCriterion("company_size not like", value, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeIn(List<String> values) {
            addCriterion("company_size in", values, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeNotIn(List<String> values) {
            addCriterion("company_size not in", values, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeBetween(String value1, String value2) {
            addCriterion("company_size between", value1, value2, "companySize");
            return (Criteria) this;
        }

        public Criteria andCompanySizeNotBetween(String value1, String value2) {
            addCriterion("company_size not between", value1, value2, "companySize");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberIsNull() {
            addCriterion("registration_number is null");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberIsNotNull() {
            addCriterion("registration_number is not null");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberEqualTo(String value) {
            addCriterion("registration_number =", value, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberNotEqualTo(String value) {
            addCriterion("registration_number <>", value, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberGreaterThan(String value) {
            addCriterion("registration_number >", value, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberGreaterThanOrEqualTo(String value) {
            addCriterion("registration_number >=", value, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberLessThan(String value) {
            addCriterion("registration_number <", value, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberLessThanOrEqualTo(String value) {
            addCriterion("registration_number <=", value, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberLike(String value) {
            addCriterion("registration_number like", value, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberNotLike(String value) {
            addCriterion("registration_number not like", value, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberIn(List<String> values) {
            addCriterion("registration_number in", values, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberNotIn(List<String> values) {
            addCriterion("registration_number not in", values, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberBetween(String value1, String value2) {
            addCriterion("registration_number between", value1, value2, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andRegistrationNumberNotBetween(String value1, String value2) {
            addCriterion("registration_number not between", value1, value2, "registrationNumber");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIsNull() {
            addCriterion("organization_code is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIsNotNull() {
            addCriterion("organization_code is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeEqualTo(String value) {
            addCriterion("organization_code =", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotEqualTo(String value) {
            addCriterion("organization_code <>", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeGreaterThan(String value) {
            addCriterion("organization_code >", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeGreaterThanOrEqualTo(String value) {
            addCriterion("organization_code >=", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLessThan(String value) {
            addCriterion("organization_code <", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLessThanOrEqualTo(String value) {
            addCriterion("organization_code <=", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLike(String value) {
            addCriterion("organization_code like", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotLike(String value) {
            addCriterion("organization_code not like", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIn(List<String> values) {
            addCriterion("organization_code in", values, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotIn(List<String> values) {
            addCriterion("organization_code not in", values, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeBetween(String value1, String value2) {
            addCriterion("organization_code between", value1, value2, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotBetween(String value1, String value2) {
            addCriterion("organization_code not between", value1, value2, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeIsNull() {
            addCriterion("company_type is null");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeIsNotNull() {
            addCriterion("company_type is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeEqualTo(String value) {
            addCriterion("company_type =", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeNotEqualTo(String value) {
            addCriterion("company_type <>", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeGreaterThan(String value) {
            addCriterion("company_type >", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeGreaterThanOrEqualTo(String value) {
            addCriterion("company_type >=", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeLessThan(String value) {
            addCriterion("company_type <", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeLessThanOrEqualTo(String value) {
            addCriterion("company_type <=", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeLike(String value) {
            addCriterion("company_type like", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeNotLike(String value) {
            addCriterion("company_type not like", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeIn(List<String> values) {
            addCriterion("company_type in", values, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeNotIn(List<String> values) {
            addCriterion("company_type not in", values, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeBetween(String value1, String value2) {
            addCriterion("company_type between", value1, value2, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeNotBetween(String value1, String value2) {
            addCriterion("company_type not between", value1, value2, "companyType");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeIsNull() {
            addCriterion("legal_representative is null");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeIsNotNull() {
            addCriterion("legal_representative is not null");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeEqualTo(String value) {
            addCriterion("legal_representative =", value, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeNotEqualTo(String value) {
            addCriterion("legal_representative <>", value, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeGreaterThan(String value) {
            addCriterion("legal_representative >", value, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeGreaterThanOrEqualTo(String value) {
            addCriterion("legal_representative >=", value, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeLessThan(String value) {
            addCriterion("legal_representative <", value, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeLessThanOrEqualTo(String value) {
            addCriterion("legal_representative <=", value, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeLike(String value) {
            addCriterion("legal_representative like", value, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeNotLike(String value) {
            addCriterion("legal_representative not like", value, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeIn(List<String> values) {
            addCriterion("legal_representative in", values, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeNotIn(List<String> values) {
            addCriterion("legal_representative not in", values, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeBetween(String value1, String value2) {
            addCriterion("legal_representative between", value1, value2, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andLegalRepresentativeNotBetween(String value1, String value2) {
            addCriterion("legal_representative not between", value1, value2, "legalRepresentative");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalIsNull() {
            addCriterion("registered_capital is null");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalIsNotNull() {
            addCriterion("registered_capital is not null");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalEqualTo(String value) {
            addCriterion("registered_capital =", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalNotEqualTo(String value) {
            addCriterion("registered_capital <>", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalGreaterThan(String value) {
            addCriterion("registered_capital >", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalGreaterThanOrEqualTo(String value) {
            addCriterion("registered_capital >=", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalLessThan(String value) {
            addCriterion("registered_capital <", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalLessThanOrEqualTo(String value) {
            addCriterion("registered_capital <=", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalLike(String value) {
            addCriterion("registered_capital like", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalNotLike(String value) {
            addCriterion("registered_capital not like", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalIn(List<String> values) {
            addCriterion("registered_capital in", values, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalNotIn(List<String> values) {
            addCriterion("registered_capital not in", values, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalBetween(String value1, String value2) {
            addCriterion("registered_capital between", value1, value2, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalNotBetween(String value1, String value2) {
            addCriterion("registered_capital not between", value1, value2, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeIsNull() {
            addCriterion("registration_time is null");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeIsNotNull() {
            addCriterion("registration_time is not null");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeEqualTo(Date value) {
            addCriterionForJDBCDate("registration_time =", value, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("registration_time <>", value, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("registration_time >", value, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("registration_time >=", value, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeLessThan(Date value) {
            addCriterionForJDBCDate("registration_time <", value, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("registration_time <=", value, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeIn(List<Date> values) {
            addCriterionForJDBCDate("registration_time in", values, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("registration_time not in", values, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("registration_time between", value1, value2, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andRegistrationTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("registration_time not between", value1, value2, "registrationTime");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateIsNull() {
            addCriterion("enterprise_state is null");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateIsNotNull() {
            addCriterion("enterprise_state is not null");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateEqualTo(String value) {
            addCriterion("enterprise_state =", value, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateNotEqualTo(String value) {
            addCriterion("enterprise_state <>", value, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateGreaterThan(String value) {
            addCriterion("enterprise_state >", value, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateGreaterThanOrEqualTo(String value) {
            addCriterion("enterprise_state >=", value, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateLessThan(String value) {
            addCriterion("enterprise_state <", value, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateLessThanOrEqualTo(String value) {
            addCriterion("enterprise_state <=", value, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateLike(String value) {
            addCriterion("enterprise_state like", value, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateNotLike(String value) {
            addCriterion("enterprise_state not like", value, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateIn(List<String> values) {
            addCriterion("enterprise_state in", values, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateNotIn(List<String> values) {
            addCriterion("enterprise_state not in", values, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateBetween(String value1, String value2) {
            addCriterion("enterprise_state between", value1, value2, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andEnterpriseStateNotBetween(String value1, String value2) {
            addCriterion("enterprise_state not between", value1, value2, "enterpriseState");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeIsNull() {
            addCriterion("capital_type is null");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeIsNotNull() {
            addCriterion("capital_type is not null");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeEqualTo(String value) {
            addCriterion("capital_type =", value, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeNotEqualTo(String value) {
            addCriterion("capital_type <>", value, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeGreaterThan(String value) {
            addCriterion("capital_type >", value, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeGreaterThanOrEqualTo(String value) {
            addCriterion("capital_type >=", value, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeLessThan(String value) {
            addCriterion("capital_type <", value, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeLessThanOrEqualTo(String value) {
            addCriterion("capital_type <=", value, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeLike(String value) {
            addCriterion("capital_type like", value, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeNotLike(String value) {
            addCriterion("capital_type not like", value, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeIn(List<String> values) {
            addCriterion("capital_type in", values, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeNotIn(List<String> values) {
            addCriterion("capital_type not in", values, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeBetween(String value1, String value2) {
            addCriterion("capital_type between", value1, value2, "capitalType");
            return (Criteria) this;
        }

        public Criteria andCapitalTypeNotBetween(String value1, String value2) {
            addCriterion("capital_type not between", value1, value2, "capitalType");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberIsNull() {
            addCriterion("insured_number is null");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberIsNotNull() {
            addCriterion("insured_number is not null");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberEqualTo(Integer value) {
            addCriterion("insured_number =", value, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberNotEqualTo(Integer value) {
            addCriterion("insured_number <>", value, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberGreaterThan(Integer value) {
            addCriterion("insured_number >", value, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("insured_number >=", value, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberLessThan(Integer value) {
            addCriterion("insured_number <", value, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberLessThanOrEqualTo(Integer value) {
            addCriterion("insured_number <=", value, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberIn(List<Integer> values) {
            addCriterion("insured_number in", values, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberNotIn(List<Integer> values) {
            addCriterion("insured_number not in", values, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberBetween(Integer value1, Integer value2) {
            addCriterion("insured_number between", value1, value2, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andInsuredNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("insured_number not between", value1, value2, "insuredNumber");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("fax is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("fax is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("fax =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("fax <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("fax >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("fax >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("fax <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("fax <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("fax like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("fax not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("fax in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("fax not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("fax between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("fax not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletIsNull() {
            addCriterion("customer_wallet is null");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletIsNotNull() {
            addCriterion("customer_wallet is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletEqualTo(BigDecimal value) {
            addCriterion("customer_wallet =", value, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletNotEqualTo(BigDecimal value) {
            addCriterion("customer_wallet <>", value, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletGreaterThan(BigDecimal value) {
            addCriterion("customer_wallet >", value, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("customer_wallet >=", value, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletLessThan(BigDecimal value) {
            addCriterion("customer_wallet <", value, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletLessThanOrEqualTo(BigDecimal value) {
            addCriterion("customer_wallet <=", value, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletIn(List<BigDecimal> values) {
            addCriterion("customer_wallet in", values, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletNotIn(List<BigDecimal> values) {
            addCriterion("customer_wallet not in", values, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("customer_wallet between", value1, value2, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerWalletNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("customer_wallet not between", value1, value2, "customerWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletIsNull() {
            addCriterion("customer_shift_wallet is null");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletIsNotNull() {
            addCriterion("customer_shift_wallet is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletEqualTo(BigDecimal value) {
            addCriterion("customer_shift_wallet =", value, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletNotEqualTo(BigDecimal value) {
            addCriterion("customer_shift_wallet <>", value, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletGreaterThan(BigDecimal value) {
            addCriterion("customer_shift_wallet >", value, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("customer_shift_wallet >=", value, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletLessThan(BigDecimal value) {
            addCriterion("customer_shift_wallet <", value, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletLessThanOrEqualTo(BigDecimal value) {
            addCriterion("customer_shift_wallet <=", value, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletIn(List<BigDecimal> values) {
            addCriterion("customer_shift_wallet in", values, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletNotIn(List<BigDecimal> values) {
            addCriterion("customer_shift_wallet not in", values, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("customer_shift_wallet between", value1, value2, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCustomerShiftWalletNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("customer_shift_wallet not between", value1, value2, "customerShiftWallet");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNull() {
            addCriterion("create_people_id is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNotNull() {
            addCriterion("create_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdEqualTo(String value) {
            addCriterion("create_people_id =", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotEqualTo(String value) {
            addCriterion("create_people_id <>", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThan(String value) {
            addCriterion("create_people_id >", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_id >=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThan(String value) {
            addCriterion("create_people_id <", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("create_people_id <=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLike(String value) {
            addCriterion("create_people_id like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotLike(String value) {
            addCriterion("create_people_id not like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIn(List<String> values) {
            addCriterion("create_people_id in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotIn(List<String> values) {
            addCriterion("create_people_id not in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdBetween(String value1, String value2) {
            addCriterion("create_people_id between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("create_people_id not between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNull() {
            addCriterion("create_tm is null");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNotNull() {
            addCriterion("create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTmEqualTo(Date value) {
            addCriterion("create_tm =", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotEqualTo(Date value) {
            addCriterion("create_tm <>", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThan(Date value) {
            addCriterion("create_tm >", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("create_tm >=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThan(Date value) {
            addCriterion("create_tm <", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThanOrEqualTo(Date value) {
            addCriterion("create_tm <=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmIn(List<Date> values) {
            addCriterion("create_tm in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotIn(List<Date> values) {
            addCriterion("create_tm not in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmBetween(Date value1, Date value2) {
            addCriterion("create_tm between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotBetween(Date value1, Date value2) {
            addCriterion("create_tm not between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNull() {
            addCriterion("update_people_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNotNull() {
            addCriterion("update_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdEqualTo(String value) {
            addCriterion("update_people_id =", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotEqualTo(String value) {
            addCriterion("update_people_id <>", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThan(String value) {
            addCriterion("update_people_id >", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("update_people_id >=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThan(String value) {
            addCriterion("update_people_id <", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("update_people_id <=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLike(String value) {
            addCriterion("update_people_id like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotLike(String value) {
            addCriterion("update_people_id not like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIn(List<String> values) {
            addCriterion("update_people_id in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotIn(List<String> values) {
            addCriterion("update_people_id not in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdBetween(String value1, String value2) {
            addCriterion("update_people_id between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("update_people_id not between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNull() {
            addCriterion("update_tm is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNotNull() {
            addCriterion("update_tm is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmEqualTo(Date value) {
            addCriterion("update_tm =", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotEqualTo(Date value) {
            addCriterion("update_tm <>", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThan(Date value) {
            addCriterion("update_tm >", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("update_tm >=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThan(Date value) {
            addCriterion("update_tm <", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThanOrEqualTo(Date value) {
            addCriterion("update_tm <=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIn(List<Date> values) {
            addCriterion("update_tm in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotIn(List<Date> values) {
            addCriterion("update_tm not in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmBetween(Date value1, Date value2) {
            addCriterion("update_tm between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotBetween(Date value1, Date value2) {
            addCriterion("update_tm not between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNull() {
            addCriterion("delete_status is null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNotNull() {
            addCriterion("delete_status is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusEqualTo(Short value) {
            addCriterion("delete_status =", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotEqualTo(Short value) {
            addCriterion("delete_status <>", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThan(Short value) {
            addCriterion("delete_status >", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("delete_status >=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThan(Short value) {
            addCriterion("delete_status <", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThanOrEqualTo(Short value) {
            addCriterion("delete_status <=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIn(List<Short> values) {
            addCriterion("delete_status in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotIn(List<Short> values) {
            addCriterion("delete_status not in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusBetween(Short value1, Short value2) {
            addCriterion("delete_status between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotBetween(Short value1, Short value2) {
            addCriterion("delete_status not between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIsNull() {
            addCriterion("owner_id is null");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIsNotNull() {
            addCriterion("owner_id is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerIdEqualTo(String value) {
            addCriterion("owner_id =", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotEqualTo(String value) {
            addCriterion("owner_id <>", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdGreaterThan(String value) {
            addCriterion("owner_id >", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdGreaterThanOrEqualTo(String value) {
            addCriterion("owner_id >=", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdLessThan(String value) {
            addCriterion("owner_id <", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdLessThanOrEqualTo(String value) {
            addCriterion("owner_id <=", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdLike(String value) {
            addCriterion("owner_id like", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotLike(String value) {
            addCriterion("owner_id not like", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIn(List<String> values) {
            addCriterion("owner_id in", values, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotIn(List<String> values) {
            addCriterion("owner_id not in", values, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdBetween(String value1, String value2) {
            addCriterion("owner_id between", value1, value2, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotBetween(String value1, String value2) {
            addCriterion("owner_id not between", value1, value2, "ownerId");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceIsNull() {
            addCriterion("customer_source is null");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceIsNotNull() {
            addCriterion("customer_source is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceEqualTo(String value) {
            addCriterion("customer_source =", value, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceNotEqualTo(String value) {
            addCriterion("customer_source <>", value, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceGreaterThan(String value) {
            addCriterion("customer_source >", value, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceGreaterThanOrEqualTo(String value) {
            addCriterion("customer_source >=", value, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceLessThan(String value) {
            addCriterion("customer_source <", value, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceLessThanOrEqualTo(String value) {
            addCriterion("customer_source <=", value, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceLike(String value) {
            addCriterion("customer_source like", value, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceNotLike(String value) {
            addCriterion("customer_source not like", value, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceIn(List<String> values) {
            addCriterion("customer_source in", values, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceNotIn(List<String> values) {
            addCriterion("customer_source not in", values, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceBetween(String value1, String value2) {
            addCriterion("customer_source between", value1, value2, "customerSource");
            return (Criteria) this;
        }

        public Criteria andCustomerSourceNotBetween(String value1, String value2) {
            addCriterion("customer_source not between", value1, value2, "customerSource");
            return (Criteria) this;
        }

        public Criteria andIndustryIsNull() {
            addCriterion("industry is null");
            return (Criteria) this;
        }

        public Criteria andIndustryIsNotNull() {
            addCriterion("industry is not null");
            return (Criteria) this;
        }

        public Criteria andIndustryEqualTo(String value) {
            addCriterion("industry =", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotEqualTo(String value) {
            addCriterion("industry <>", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryGreaterThan(String value) {
            addCriterion("industry >", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryGreaterThanOrEqualTo(String value) {
            addCriterion("industry >=", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLessThan(String value) {
            addCriterion("industry <", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLessThanOrEqualTo(String value) {
            addCriterion("industry <=", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLike(String value) {
            addCriterion("industry like", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotLike(String value) {
            addCriterion("industry not like", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryIn(List<String> values) {
            addCriterion("industry in", values, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotIn(List<String> values) {
            addCriterion("industry not in", values, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryBetween(String value1, String value2) {
            addCriterion("industry between", value1, value2, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotBetween(String value1, String value2) {
            addCriterion("industry not between", value1, value2, "industry");
            return (Criteria) this;
        }

        public Criteria andIdentificationIsNull() {
            addCriterion("identification is null");
            return (Criteria) this;
        }

        public Criteria andIdentificationIsNotNull() {
            addCriterion("identification is not null");
            return (Criteria) this;
        }

        public Criteria andIdentificationEqualTo(String value) {
            addCriterion("identification =", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationNotEqualTo(String value) {
            addCriterion("identification <>", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationGreaterThan(String value) {
            addCriterion("identification >", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationGreaterThanOrEqualTo(String value) {
            addCriterion("identification >=", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationLessThan(String value) {
            addCriterion("identification <", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationLessThanOrEqualTo(String value) {
            addCriterion("identification <=", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationLike(String value) {
            addCriterion("identification like", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationNotLike(String value) {
            addCriterion("identification not like", value, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationIn(List<String> values) {
            addCriterion("identification in", values, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationNotIn(List<String> values) {
            addCriterion("identification not in", values, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationBetween(String value1, String value2) {
            addCriterion("identification between", value1, value2, "identification");
            return (Criteria) this;
        }

        public Criteria andIdentificationNotBetween(String value1, String value2) {
            addCriterion("identification not between", value1, value2, "identification");
            return (Criteria) this;
        }

        public Criteria andDealStatusIsNull() {
            addCriterion("deal_status is null");
            return (Criteria) this;
        }

        public Criteria andDealStatusIsNotNull() {
            addCriterion("deal_status is not null");
            return (Criteria) this;
        }

        public Criteria andDealStatusEqualTo(String value) {
            addCriterion("deal_status =", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusNotEqualTo(String value) {
            addCriterion("deal_status <>", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusGreaterThan(String value) {
            addCriterion("deal_status >", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusGreaterThanOrEqualTo(String value) {
            addCriterion("deal_status >=", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusLessThan(String value) {
            addCriterion("deal_status <", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusLessThanOrEqualTo(String value) {
            addCriterion("deal_status <=", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusLike(String value) {
            addCriterion("deal_status like", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusNotLike(String value) {
            addCriterion("deal_status not like", value, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusIn(List<String> values) {
            addCriterion("deal_status in", values, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusNotIn(List<String> values) {
            addCriterion("deal_status not in", values, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusBetween(String value1, String value2) {
            addCriterion("deal_status between", value1, value2, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andDealStatusNotBetween(String value1, String value2) {
            addCriterion("deal_status not between", value1, value2, "dealStatus");
            return (Criteria) this;
        }

        public Criteria andUploadIdIsNull() {
            addCriterion("upload_id is null");
            return (Criteria) this;
        }

        public Criteria andUploadIdIsNotNull() {
            addCriterion("upload_id is not null");
            return (Criteria) this;
        }

        public Criteria andUploadIdEqualTo(String value) {
            addCriterion("upload_id =", value, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdNotEqualTo(String value) {
            addCriterion("upload_id <>", value, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdGreaterThan(String value) {
            addCriterion("upload_id >", value, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdGreaterThanOrEqualTo(String value) {
            addCriterion("upload_id >=", value, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdLessThan(String value) {
            addCriterion("upload_id <", value, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdLessThanOrEqualTo(String value) {
            addCriterion("upload_id <=", value, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdLike(String value) {
            addCriterion("upload_id like", value, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdNotLike(String value) {
            addCriterion("upload_id not like", value, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdIn(List<String> values) {
            addCriterion("upload_id in", values, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdNotIn(List<String> values) {
            addCriterion("upload_id not in", values, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdBetween(String value1, String value2) {
            addCriterion("upload_id between", value1, value2, "uploadId");
            return (Criteria) this;
        }

        public Criteria andUploadIdNotBetween(String value1, String value2) {
            addCriterion("upload_id not between", value1, value2, "uploadId");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingIsNull() {
            addCriterion("customer_rating is null");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingIsNotNull() {
            addCriterion("customer_rating is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingEqualTo(String value) {
            addCriterion("customer_rating =", value, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingNotEqualTo(String value) {
            addCriterion("customer_rating <>", value, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingGreaterThan(String value) {
            addCriterion("customer_rating >", value, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingGreaterThanOrEqualTo(String value) {
            addCriterion("customer_rating >=", value, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingLessThan(String value) {
            addCriterion("customer_rating <", value, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingLessThanOrEqualTo(String value) {
            addCriterion("customer_rating <=", value, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingLike(String value) {
            addCriterion("customer_rating like", value, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingNotLike(String value) {
            addCriterion("customer_rating not like", value, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingIn(List<String> values) {
            addCriterion("customer_rating in", values, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingNotIn(List<String> values) {
            addCriterion("customer_rating not in", values, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingBetween(String value1, String value2) {
            addCriterion("customer_rating between", value1, value2, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCustomerRatingNotBetween(String value1, String value2) {
            addCriterion("customer_rating not between", value1, value2, "customerRating");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusIsNull() {
            addCriterion("current_status is null");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusIsNotNull() {
            addCriterion("current_status is not null");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusEqualTo(Short value) {
            addCriterion("current_status =", value, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusNotEqualTo(Short value) {
            addCriterion("current_status <>", value, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusGreaterThan(Short value) {
            addCriterion("current_status >", value, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("current_status >=", value, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusLessThan(Short value) {
            addCriterion("current_status <", value, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusLessThanOrEqualTo(Short value) {
            addCriterion("current_status <=", value, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusIn(List<Short> values) {
            addCriterion("current_status in", values, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusNotIn(List<Short> values) {
            addCriterion("current_status not in", values, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusBetween(Short value1, Short value2) {
            addCriterion("current_status between", value1, value2, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andCurrentStatusNotBetween(Short value1, Short value2) {
            addCriterion("current_status not between", value1, value2, "currentStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelIsNull() {
            addCriterion("membership_level is null");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelIsNotNull() {
            addCriterion("membership_level is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelEqualTo(Integer value) {
            addCriterion("membership_level =", value, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelNotEqualTo(Integer value) {
            addCriterion("membership_level <>", value, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelGreaterThan(Integer value) {
            addCriterion("membership_level >", value, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("membership_level >=", value, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelLessThan(Integer value) {
            addCriterion("membership_level <", value, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelLessThanOrEqualTo(Integer value) {
            addCriterion("membership_level <=", value, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelIn(List<Integer> values) {
            addCriterion("membership_level in", values, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelNotIn(List<Integer> values) {
            addCriterion("membership_level not in", values, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelBetween(Integer value1, Integer value2) {
            addCriterion("membership_level between", value1, value2, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("membership_level not between", value1, value2, "membershipLevel");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNull() {
            addCriterion("contact_person is null");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNotNull() {
            addCriterion("contact_person is not null");
            return (Criteria) this;
        }

        public Criteria andContactPersonEqualTo(String value) {
            addCriterion("contact_person =", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotEqualTo(String value) {
            addCriterion("contact_person <>", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThan(String value) {
            addCriterion("contact_person >", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThanOrEqualTo(String value) {
            addCriterion("contact_person >=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThan(String value) {
            addCriterion("contact_person <", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThanOrEqualTo(String value) {
            addCriterion("contact_person <=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLike(String value) {
            addCriterion("contact_person like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotLike(String value) {
            addCriterion("contact_person not like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonIn(List<String> values) {
            addCriterion("contact_person in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotIn(List<String> values) {
            addCriterion("contact_person not in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonBetween(String value1, String value2) {
            addCriterion("contact_person between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotBetween(String value1, String value2) {
            addCriterion("contact_person not between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneIsNull() {
            addCriterion("contact_person_phone is null");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneIsNotNull() {
            addCriterion("contact_person_phone is not null");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneEqualTo(String value) {
            addCriterion("contact_person_phone =", value, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneNotEqualTo(String value) {
            addCriterion("contact_person_phone <>", value, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneGreaterThan(String value) {
            addCriterion("contact_person_phone >", value, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("contact_person_phone >=", value, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneLessThan(String value) {
            addCriterion("contact_person_phone <", value, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneLessThanOrEqualTo(String value) {
            addCriterion("contact_person_phone <=", value, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneLike(String value) {
            addCriterion("contact_person_phone like", value, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneNotLike(String value) {
            addCriterion("contact_person_phone not like", value, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneIn(List<String> values) {
            addCriterion("contact_person_phone in", values, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneNotIn(List<String> values) {
            addCriterion("contact_person_phone not in", values, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneBetween(String value1, String value2) {
            addCriterion("contact_person_phone between", value1, value2, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andContactPersonPhoneNotBetween(String value1, String value2) {
            addCriterion("contact_person_phone not between", value1, value2, "contactPersonPhone");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberIsNull() {
            addCriterion("financial_number is null");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberIsNotNull() {
            addCriterion("financial_number is not null");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberEqualTo(Integer value) {
            addCriterion("financial_number =", value, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberNotEqualTo(Integer value) {
            addCriterion("financial_number <>", value, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberGreaterThan(Integer value) {
            addCriterion("financial_number >", value, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("financial_number >=", value, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberLessThan(Integer value) {
            addCriterion("financial_number <", value, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberLessThanOrEqualTo(Integer value) {
            addCriterion("financial_number <=", value, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberIn(List<Integer> values) {
            addCriterion("financial_number in", values, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberNotIn(List<Integer> values) {
            addCriterion("financial_number not in", values, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberBetween(Integer value1, Integer value2) {
            addCriterion("financial_number between", value1, value2, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andFinancialNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("financial_number not between", value1, value2, "financialNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmIsNull() {
            addCriterion("membership_start_tm is null");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmIsNotNull() {
            addCriterion("membership_start_tm is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmEqualTo(Date value) {
            addCriterion("membership_start_tm =", value, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmNotEqualTo(Date value) {
            addCriterion("membership_start_tm <>", value, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmGreaterThan(Date value) {
            addCriterion("membership_start_tm >", value, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmGreaterThanOrEqualTo(Date value) {
            addCriterion("membership_start_tm >=", value, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmLessThan(Date value) {
            addCriterion("membership_start_tm <", value, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmLessThanOrEqualTo(Date value) {
            addCriterion("membership_start_tm <=", value, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmIn(List<Date> values) {
            addCriterion("membership_start_tm in", values, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmNotIn(List<Date> values) {
            addCriterion("membership_start_tm not in", values, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmBetween(Date value1, Date value2) {
            addCriterion("membership_start_tm between", value1, value2, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipStartTmNotBetween(Date value1, Date value2) {
            addCriterion("membership_start_tm not between", value1, value2, "membershipStartTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmIsNull() {
            addCriterion("membership_expiration_tm is null");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmIsNotNull() {
            addCriterion("membership_expiration_tm is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmEqualTo(Date value) {
            addCriterion("membership_expiration_tm =", value, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmNotEqualTo(Date value) {
            addCriterion("membership_expiration_tm <>", value, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmGreaterThan(Date value) {
            addCriterion("membership_expiration_tm >", value, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmGreaterThanOrEqualTo(Date value) {
            addCriterion("membership_expiration_tm >=", value, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmLessThan(Date value) {
            addCriterion("membership_expiration_tm <", value, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmLessThanOrEqualTo(Date value) {
            addCriterion("membership_expiration_tm <=", value, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmIn(List<Date> values) {
            addCriterion("membership_expiration_tm in", values, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmNotIn(List<Date> values) {
            addCriterion("membership_expiration_tm not in", values, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmBetween(Date value1, Date value2) {
            addCriterion("membership_expiration_tm between", value1, value2, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andMembershipExpirationTmNotBetween(Date value1, Date value2) {
            addCriterion("membership_expiration_tm not between", value1, value2, "membershipExpirationTm");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameIsNull() {
            addCriterion("workplace_name is null");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameIsNotNull() {
            addCriterion("workplace_name is not null");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameEqualTo(String value) {
            addCriterion("workplace_name =", value, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameNotEqualTo(String value) {
            addCriterion("workplace_name <>", value, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameGreaterThan(String value) {
            addCriterion("workplace_name >", value, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameGreaterThanOrEqualTo(String value) {
            addCriterion("workplace_name >=", value, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameLessThan(String value) {
            addCriterion("workplace_name <", value, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameLessThanOrEqualTo(String value) {
            addCriterion("workplace_name <=", value, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameLike(String value) {
            addCriterion("workplace_name like", value, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameNotLike(String value) {
            addCriterion("workplace_name not like", value, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameIn(List<String> values) {
            addCriterion("workplace_name in", values, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameNotIn(List<String> values) {
            addCriterion("workplace_name not in", values, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameBetween(String value1, String value2) {
            addCriterion("workplace_name between", value1, value2, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andWorkplaceNameNotBetween(String value1, String value2) {
            addCriterion("workplace_name not between", value1, value2, "workplaceName");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdIsNull() {
            addCriterion("customer_pool_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdIsNotNull() {
            addCriterion("customer_pool_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdEqualTo(String value) {
            addCriterion("customer_pool_id =", value, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdNotEqualTo(String value) {
            addCriterion("customer_pool_id <>", value, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdGreaterThan(String value) {
            addCriterion("customer_pool_id >", value, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdGreaterThanOrEqualTo(String value) {
            addCriterion("customer_pool_id >=", value, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdLessThan(String value) {
            addCriterion("customer_pool_id <", value, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdLessThanOrEqualTo(String value) {
            addCriterion("customer_pool_id <=", value, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdLike(String value) {
            addCriterion("customer_pool_id like", value, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdNotLike(String value) {
            addCriterion("customer_pool_id not like", value, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdIn(List<String> values) {
            addCriterion("customer_pool_id in", values, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdNotIn(List<String> values) {
            addCriterion("customer_pool_id not in", values, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdBetween(String value1, String value2) {
            addCriterion("customer_pool_id between", value1, value2, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andCustomerPoolIdNotBetween(String value1, String value2) {
            addCriterion("customer_pool_id not between", value1, value2, "customerPoolId");
            return (Criteria) this;
        }

        public Criteria andAccountIdIsNull() {
            addCriterion("account_id is null");
            return (Criteria) this;
        }

        public Criteria andAccountIdIsNotNull() {
            addCriterion("account_id is not null");
            return (Criteria) this;
        }

        public Criteria andAccountIdEqualTo(String value) {
            addCriterion("account_id =", value, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdNotEqualTo(String value) {
            addCriterion("account_id <>", value, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdGreaterThan(String value) {
            addCriterion("account_id >", value, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdGreaterThanOrEqualTo(String value) {
            addCriterion("account_id >=", value, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdLessThan(String value) {
            addCriterion("account_id <", value, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdLessThanOrEqualTo(String value) {
            addCriterion("account_id <=", value, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdLike(String value) {
            addCriterion("account_id like", value, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdNotLike(String value) {
            addCriterion("account_id not like", value, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdIn(List<String> values) {
            addCriterion("account_id in", values, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdNotIn(List<String> values) {
            addCriterion("account_id not in", values, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdBetween(String value1, String value2) {
            addCriterion("account_id between", value1, value2, "accountId");
            return (Criteria) this;
        }

        public Criteria andAccountIdNotBetween(String value1, String value2) {
            addCriterion("account_id not between", value1, value2, "accountId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdIsNull() {
            addCriterion("receive_people_id is null");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdIsNotNull() {
            addCriterion("receive_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdEqualTo(String value) {
            addCriterion("receive_people_id =", value, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdNotEqualTo(String value) {
            addCriterion("receive_people_id <>", value, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdGreaterThan(String value) {
            addCriterion("receive_people_id >", value, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("receive_people_id >=", value, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdLessThan(String value) {
            addCriterion("receive_people_id <", value, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("receive_people_id <=", value, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdLike(String value) {
            addCriterion("receive_people_id like", value, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdNotLike(String value) {
            addCriterion("receive_people_id not like", value, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdIn(List<String> values) {
            addCriterion("receive_people_id in", values, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdNotIn(List<String> values) {
            addCriterion("receive_people_id not in", values, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdBetween(String value1, String value2) {
            addCriterion("receive_people_id between", value1, value2, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andReceivePeopleIdNotBetween(String value1, String value2) {
            addCriterion("receive_people_id not between", value1, value2, "receivePeopleId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdIsNull() {
            addCriterion("assigned_person_id is null");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdIsNotNull() {
            addCriterion("assigned_person_id is not null");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdEqualTo(String value) {
            addCriterion("assigned_person_id =", value, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdNotEqualTo(String value) {
            addCriterion("assigned_person_id <>", value, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdGreaterThan(String value) {
            addCriterion("assigned_person_id >", value, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdGreaterThanOrEqualTo(String value) {
            addCriterion("assigned_person_id >=", value, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdLessThan(String value) {
            addCriterion("assigned_person_id <", value, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdLessThanOrEqualTo(String value) {
            addCriterion("assigned_person_id <=", value, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdLike(String value) {
            addCriterion("assigned_person_id like", value, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdNotLike(String value) {
            addCriterion("assigned_person_id not like", value, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdIn(List<String> values) {
            addCriterion("assigned_person_id in", values, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdNotIn(List<String> values) {
            addCriterion("assigned_person_id not in", values, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdBetween(String value1, String value2) {
            addCriterion("assigned_person_id between", value1, value2, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andAssignedPersonIdNotBetween(String value1, String value2) {
            addCriterion("assigned_person_id not between", value1, value2, "assignedPersonId");
            return (Criteria) this;
        }

        public Criteria andProtectStatusIsNull() {
            addCriterion("protect_status is null");
            return (Criteria) this;
        }

        public Criteria andProtectStatusIsNotNull() {
            addCriterion("protect_status is not null");
            return (Criteria) this;
        }

        public Criteria andProtectStatusEqualTo(Integer value) {
            addCriterion("protect_status =", value, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusNotEqualTo(Integer value) {
            addCriterion("protect_status <>", value, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusGreaterThan(Integer value) {
            addCriterion("protect_status >", value, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("protect_status >=", value, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusLessThan(Integer value) {
            addCriterion("protect_status <", value, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusLessThanOrEqualTo(Integer value) {
            addCriterion("protect_status <=", value, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusIn(List<Integer> values) {
            addCriterion("protect_status in", values, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusNotIn(List<Integer> values) {
            addCriterion("protect_status not in", values, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusBetween(Integer value1, Integer value2) {
            addCriterion("protect_status between", value1, value2, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andProtectStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("protect_status not between", value1, value2, "protectStatus");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersIsNull() {
            addCriterion("potential_customers is null");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersIsNotNull() {
            addCriterion("potential_customers is not null");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersEqualTo(Integer value) {
            addCriterion("potential_customers =", value, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersNotEqualTo(Integer value) {
            addCriterion("potential_customers <>", value, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersGreaterThan(Integer value) {
            addCriterion("potential_customers >", value, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersGreaterThanOrEqualTo(Integer value) {
            addCriterion("potential_customers >=", value, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersLessThan(Integer value) {
            addCriterion("potential_customers <", value, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersLessThanOrEqualTo(Integer value) {
            addCriterion("potential_customers <=", value, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersIn(List<Integer> values) {
            addCriterion("potential_customers in", values, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersNotIn(List<Integer> values) {
            addCriterion("potential_customers not in", values, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersBetween(Integer value1, Integer value2) {
            addCriterion("potential_customers between", value1, value2, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andPotentialCustomersNotBetween(Integer value1, Integer value2) {
            addCriterion("potential_customers not between", value1, value2, "potentialCustomers");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerIsNull() {
            addCriterion("new_order_renewal_customer is null");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerIsNotNull() {
            addCriterion("new_order_renewal_customer is not null");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerEqualTo(Integer value) {
            addCriterion("new_order_renewal_customer =", value, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerNotEqualTo(Integer value) {
            addCriterion("new_order_renewal_customer <>", value, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerGreaterThan(Integer value) {
            addCriterion("new_order_renewal_customer >", value, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerGreaterThanOrEqualTo(Integer value) {
            addCriterion("new_order_renewal_customer >=", value, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerLessThan(Integer value) {
            addCriterion("new_order_renewal_customer <", value, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerLessThanOrEqualTo(Integer value) {
            addCriterion("new_order_renewal_customer <=", value, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerIn(List<Integer> values) {
            addCriterion("new_order_renewal_customer in", values, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerNotIn(List<Integer> values) {
            addCriterion("new_order_renewal_customer not in", values, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerBetween(Integer value1, Integer value2) {
            addCriterion("new_order_renewal_customer between", value1, value2, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andNewOrderRenewalCustomerNotBetween(Integer value1, Integer value2) {
            addCriterion("new_order_renewal_customer not between", value1, value2, "newOrderRenewalCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerIsNull() {
            addCriterion("lose_customer is null");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerIsNotNull() {
            addCriterion("lose_customer is not null");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerEqualTo(Integer value) {
            addCriterion("lose_customer =", value, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerNotEqualTo(Integer value) {
            addCriterion("lose_customer <>", value, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerGreaterThan(Integer value) {
            addCriterion("lose_customer >", value, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerGreaterThanOrEqualTo(Integer value) {
            addCriterion("lose_customer >=", value, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerLessThan(Integer value) {
            addCriterion("lose_customer <", value, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerLessThanOrEqualTo(Integer value) {
            addCriterion("lose_customer <=", value, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerIn(List<Integer> values) {
            addCriterion("lose_customer in", values, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerNotIn(List<Integer> values) {
            addCriterion("lose_customer not in", values, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerBetween(Integer value1, Integer value2) {
            addCriterion("lose_customer between", value1, value2, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andLoseCustomerNotBetween(Integer value1, Integer value2) {
            addCriterion("lose_customer not between", value1, value2, "loseCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerIsNull() {
            addCriterion("old_customer is null");
            return (Criteria) this;
        }

        public Criteria andOldCustomerIsNotNull() {
            addCriterion("old_customer is not null");
            return (Criteria) this;
        }

        public Criteria andOldCustomerEqualTo(Integer value) {
            addCriterion("old_customer =", value, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerNotEqualTo(Integer value) {
            addCriterion("old_customer <>", value, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerGreaterThan(Integer value) {
            addCriterion("old_customer >", value, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerGreaterThanOrEqualTo(Integer value) {
            addCriterion("old_customer >=", value, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerLessThan(Integer value) {
            addCriterion("old_customer <", value, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerLessThanOrEqualTo(Integer value) {
            addCriterion("old_customer <=", value, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerIn(List<Integer> values) {
            addCriterion("old_customer in", values, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerNotIn(List<Integer> values) {
            addCriterion("old_customer not in", values, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerBetween(Integer value1, Integer value2) {
            addCriterion("old_customer between", value1, value2, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andOldCustomerNotBetween(Integer value1, Integer value2) {
            addCriterion("old_customer not between", value1, value2, "oldCustomer");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataIsNull() {
            addCriterion("member_error_data is null");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataIsNotNull() {
            addCriterion("member_error_data is not null");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataEqualTo(Integer value) {
            addCriterion("member_error_data =", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataNotEqualTo(Integer value) {
            addCriterion("member_error_data <>", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataGreaterThan(Integer value) {
            addCriterion("member_error_data >", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataGreaterThanOrEqualTo(Integer value) {
            addCriterion("member_error_data >=", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataLessThan(Integer value) {
            addCriterion("member_error_data <", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataLessThanOrEqualTo(Integer value) {
            addCriterion("member_error_data <=", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataIn(List<Integer> values) {
            addCriterion("member_error_data in", values, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataNotIn(List<Integer> values) {
            addCriterion("member_error_data not in", values, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataBetween(Integer value1, Integer value2) {
            addCriterion("member_error_data between", value1, value2, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataNotBetween(Integer value1, Integer value2) {
            addCriterion("member_error_data not between", value1, value2, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andCheckTmIsNull() {
            addCriterion("check_tm is null");
            return (Criteria) this;
        }

        public Criteria andCheckTmIsNotNull() {
            addCriterion("check_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCheckTmEqualTo(Date value) {
            addCriterion("check_tm =", value, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmNotEqualTo(Date value) {
            addCriterion("check_tm <>", value, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmGreaterThan(Date value) {
            addCriterion("check_tm >", value, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmGreaterThanOrEqualTo(Date value) {
            addCriterion("check_tm >=", value, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmLessThan(Date value) {
            addCriterion("check_tm <", value, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmLessThanOrEqualTo(Date value) {
            addCriterion("check_tm <=", value, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmIn(List<Date> values) {
            addCriterion("check_tm in", values, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmNotIn(List<Date> values) {
            addCriterion("check_tm not in", values, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmBetween(Date value1, Date value2) {
            addCriterion("check_tm between", value1, value2, "checkTm");
            return (Criteria) this;
        }

        public Criteria andCheckTmNotBetween(Date value1, Date value2) {
            addCriterion("check_tm not between", value1, value2, "checkTm");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusIsNull() {
            addCriterion("update_status is null");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusIsNotNull() {
            addCriterion("update_status is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusEqualTo(Short value) {
            addCriterion("update_status =", value, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusNotEqualTo(Short value) {
            addCriterion("update_status <>", value, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusGreaterThan(Short value) {
            addCriterion("update_status >", value, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("update_status >=", value, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusLessThan(Short value) {
            addCriterion("update_status <", value, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusLessThanOrEqualTo(Short value) {
            addCriterion("update_status <=", value, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusIn(List<Short> values) {
            addCriterion("update_status in", values, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusNotIn(List<Short> values) {
            addCriterion("update_status not in", values, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusBetween(Short value1, Short value2) {
            addCriterion("update_status between", value1, value2, "updateStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateStatusNotBetween(Short value1, Short value2) {
            addCriterion("update_status not between", value1, value2, "updateStatus");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}